internet.com Sitemap · Experts · Tools · Services · Newsletters · About
WebReference.com - The Webmaster's Reference Library - Web Authoring Tips and Tutorials for Developers
Free WebReference Newsletters
HTML (M-F)
Text (M,TH)
Languages
ASP
CSS
DHTML
HTML
JavaScript
Perl
PHP
RSS
XHTML
XML
Video
Sitemap
Articles
Authoring
Design
Internet
Multimedia
Programming
Promotion
Reviews
Search Engine Resources
WebDev Jobs
Reference
3D
Color Codes
Design
Graphics
HTML Tags
HTML Characters
JavaScript Core
XML
Video
Services
Affiliates
Browser Sniffers
Compare Prices
Domains
Forums
Technology Jobs
RSS News
Scripts
Search
Validation
Code Tools
Browser Sniffers
HTML
JavaScript
HierMenus Central
About
Latest Version
Find a Web Host with:
CGI Capabilities
MySQL
PHP
Unix Hosting
Telnet/SSH
Cold Fusion
advanced search
WebDeveloper.com
Stats
Yesterday
33098 Visitors
OP 1.51%
Saf 2.04%
NS 1.86%
FF 29.82%
IE 41.64%

WebDeveloper.com
Developer Channel
FlashKit.com
HierMenusCentral.com
JavaScript.com
JavaScriptSource
Jobs
ScriptSearch
StreamingMediaWorld
Web Developer's Journal
Web Developer's Virtual Library
WebDeveloper.com
Webreference
Web Hosts
XMLfiles.com
Latest DevX News

Coding Options for Building InfoPath Forms

Create a JSF Portlet with Oracle WebCenter Suite and JDeveloper

Book Excerpt: ASP.NET AJAX in Action

Boost Web Service Performance in JAX-WS with Fast Infoset

Insert an XML Schema into an XQuery Query
JS Tip Archive
Dynamic Style Evolution
Were you around when dynamic styles started? Learn how dynamic styles evolved over the years. - Similar Tips

internet.com
IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers
WebReference.com: Dev the Web™ Add Newsfeed

New Job Search / Search Results / Oracle Report Developer (IL)

Oracle Report Developer (IL) - Next Step Systems
LOCATION: US-IL-Elk Grove Village
COMPANY: Next Step Systems
INTERNAL JOB #: OrclRprtDev-IL-PP
POSTED: 2/8/2010
JOB SKILLS: Database Systems, Software Development
JOB TYPE: W2
START DATE: asap
PAY RATE: $50,000 - $65,000 / year
TRAVEL: none required


JOB DESCRIPTION:
$50-$65K

Key skills: Oracle Report Builder 10g, Oracle Discoverer, PL/SQL, Advanced SQL, MS Access, Database Security, Advanced Excel, Oracle Applications Express, Oracle Portal, XML

Description:
Oracle Developer with 2-4 years of experience in Oracle Reports and Discoverer in a non R11i environment. Extensive experience writing PL/SQL procedures, packages, triggers. Any experience with Oracle Application Express, Oracle Portal and XML Gateway would be a plus. Apply knowledge of Oracle development tools, principles of data modeling to design and create custom reports and analyze and convert financial and/or manufacturing data into business intelligence.

Essential Duties and Responsibilities:
* Interact with subject matter experts and identify data elements and business rules to be embedded in the reports and design Discoverer Business Areas.
* Strong in PL/SQL: Create complex packages, procedures, and functions, performance tuning of SQL code to support ETL activities. Knowledge of Oracle Warehouse Builder is a plus.
* Knowledge of advanced SQL techniques like using Analytical Functions, knowledge of Materialized views, designing data models and ability to transform these into physical database design.
* Proficient in understanding and maintaining existing reports and developing new reports using Oracle Reports Builder 10g.
* To support ad-hoc reporting and analytics, be able to design new data models capturing the business requirements for detailed dimensional analytics and have the ability to independently create Discoverer business areas and their underlying detail and summary folders.
* Knowledge of advanced SQL techniques like using Analytical Functions, knowledge of Materialized views, designing data models and ability to transform these into physical database design.
* Be proficient in understanding and maintaining existing Business Areas and developing new summaries, hierarchies and folders using Oracle Discoverer 10g.

Required Skills:
- Oracle Application Server 9i & 10g
- Oracle Portal 9i & 10g
- Oracle Reports 9i & 10g
- Oracle Discover 9i & 10g
- Oracle Forms 9i & 10g
- Oracle Business Intelligence Suite 9i & 10g

Oracle Reports:
Develop complex Oracle reports that utilize the following:
- Multiple queries
- Multiple groups and levels of repeating frames
- Calls to PL/SQL packages, procedures and functions
- Formula, placeholder and summary columns
- Materialized views
- Format triggers & layout customization
- Lexical parameter
-* Export to Excel
- Oracle Reports deployment in Oracle Application Server 10g

Discoverer:
- Experience with Discoverer Administrator, Discoverer Plus and Discoverer Viewer 10G.
- Work with non Oracle E-Business Applications EULs.
- Design and create business areas to meet business requirements.
- Work with end users to identify most appropriate data and labels.
- Design materialized views and tables for use in Discoverer.
- Use PL/SQL to integrate data sets, perform various calculations and summaries for use by workbooks.
- Maintain joins, hierarchies, item classes.
- Create custom folders and summary folders.
- Create and register custom PL/SQL functions in Discoverer.
- Sharing and scheduling workbooks.
- Know the appropriate usage of Discoverer and its limitations.

Security:
- Setup custom security within Discoverer and Oracle Reports.
- Setup database security within Discoverer.
- Integrate Discoverer with single sign on.
- Administer public and private connections.
- Register Discoverer workbooks within Oracle Portal.
- Administration of Discoverer user privileges.

Education and/or Experience:
- Bachelors degree (B.S.) in Computer Science or equivalent with two to four years related experience and/or training with proven track record; OCP a plus.
- Experience in Business Intelligence, report writing and financial data analytics; be proficient in MS Access, PowerPoint and Word and Advanced in Excel.

CONTACT INFORMATION:
Mike Stapinski
Email Mike Stapinski
 
Next Step Systems
1212 S. Naperville Blvd.
Suite 119
Naperville, IL 60540
630.428.0600 T
http://www.nextstepsystems.com

 
Start New Job Search
Post Your Resume
Jobseeker Login
 
 
 
Resources for Employers:

It's fast and easy. Posting your job takes just minutes.
Target hard to reach passive IT jobseekers.
Post one 30 day job ad for just $279.

With job packs you reduce your cost per posting by up to 50%
Better exposure. Priority postings list at top of job search results.
Job Packs are available in increments of 3, 5, and 10 postings


The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers